//package com.hpf.cloud.utils;
//
//import cn.hutool.core.io.FileUtil;
//import cn.hutool.core.util.StrUtil;
//import cn.hutool.poi.excel.ExcelReader;
//import cn.hutool.poi.excel.ExcelUtil;
//import com.csvreader.CsvReader;
//
//import java.io.BufferedInputStream;
//import java.io.BufferedReader;
//import java.io.BufferedWriter;
//import java.nio.charset.Charset;
//import java.util.Arrays;
//import java.util.List;
//
///**
// * @description:
// * @datetime: 2020/11/22 20:00
// * @author: huangpengfei
// */
//public class CsvUtils {
//
//    public static void main(String[] args) {
//        String filePath = "D:\\usr\\word\\file\\sqlresult_5438901.csv";
//        CsvReader reader = null;
//        try {
//            reader = new CsvReader(filePath,',', Charset.forName("UTF-8"));
//            //跳过表头,不跳可以注释掉
//            reader.readHeaders();
//            BufferedWriter writer = FileUtil.getWriter("D:\\usr\\word\\file\\sql.txt", "UTF-8", false);
//            while(reader.readRecord()){
//                writer.write("update dzj.t_case set case_imgs=\'" + reader.get(1) + "\', assistant_examination_part=\'"+reader.get(2)+"\' where id = \'" + reader.get(0) + "\';");
//                writer.newLine();
//            }
//            writer.close();
//        } catch (Exception e) {
//            e.printStackTrace();
//        } finally {
//            if(null != reader){
//                reader.close();
//            }
//        }
//    }
//}
